SET IDENTITY_INSERT [system_modules] ON

insert into system_modules (ID, NAME, PATH, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US, DESCN_HK, DESCN_US, LABEL_ID)
values (43, '督办看板', 'inspect', '', '../../modules/inspect/inspectPort.do?method=inspectPort', '_self', 804, 1, '督办看板', '', '', '', '', 8);

SET IDENTITY_INSERT [system_modules] OFF


SET IDENTITY_INSERT [system_menus] ON

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1000, '督办看板', 'inspect', '0', '', '../../modules/inspect/inspectPort.do?method=inspectPort', '_self', 1000, 1, '督办看板', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1001, '督办看板开始', 'inspect', '8', '', '../../modules/inspect/inspectPort.do?method=inspectPort', '_self', 1001, 1, '督办看板开始', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1002, '新建督办', 'inspect', '1', '', '../../modules/inspect/inspectFile.do?method=create', '_self', 1002, 1, '新建督办', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1003, '督办草稿箱', 'inspect', '1', '', '../../modules/inspect/inspectFile.do?method=draft', '_self', 1003, 1, '督办草稿箱', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1004, '待办督办', 'inspect', '1', '', '../../modules/inspect/inspectProceed.do?method=findReceiveProceed', '_self', 1004, 1, '待办督办', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1005, '已发督办', 'inspect', '1', '', '../../modules/inspect/inspectProceed.do?method=findSendProceed', '_self', 1005, 1, '已发督办', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1006, '已办督办', 'inspect', '1', '', '../../modules/inspect/inspectProceed.do?method=findFinishProceed', '_self', 1006, 1, '已办督办', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1007, '督办审核', 'inspect', '1', '', '../../modules/inspect/inspectAudit.do', '_self', 1007, 1, '督办审核', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1008, '督办查询', 'inspect', '1', '', '../../modules/inspect/inspectFind.do?method=inspectFind', '_self', 1008, 1, '督办查询', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1009, '督办考核', 'inspect', '1', '', '../../modules/inspect/inspectReport.do?method=dispatcher', '_self', 1009, 1, '督办考核', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1010, '权限管理', 'inspect', '1', '', '../../modules/inspect/inspectObserver.do', '_self', 1010, 1, '权限管理', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1011, '督办类型设置', 'inspect', '1', '', '../../modules/inspect/inspectType.do?ec_s_pos=asc', '_self', 1011, 1, '督办类型设置', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1012, '督办编号设置', 'inspect', '1', '', '../../modules/inspect/inspectSnSet.do', '_self', 1012, 1, '督办编号设置', '', '');

insert into system_menus (ID, NAME, PATH, TYPE, ICON, URL, TARGET, POS, ISDISPLAY, DESCN, NAME_HK, NAME_US)
values (1020, '督办看板结束', 'inspect', '9', '', '../../modules/inspect/inspectPort.do?method=inspectPort', '_self', 1020, 1, '督办看板结束', '', '');
SET IDENTITY_INSERT [system_menus] OFF

SET IDENTITY_INSERT [system_perms] ON
insert into system_perms (ID, NAME, DESCN, OPERATION, STATUS, PATH, MENUS, OPERATION_HK, OPERATION_US)
values (122, 'AUTH_MODULES_INSPECT_USER', '新增督办', '新增督办', '1', 'inspect', '1000,1001,1002,1003,1005,1008,1020', '', '');

insert into system_perms (ID, NAME, DESCN, OPERATION, STATUS, PATH, MENUS, OPERATION_HK, OPERATION_US)
values (123, 'AUTH_MODULES_INSPECT_PROCEED', '办理督办', '办理督办', '1', 'inspect', '1000,1001,1004,1006,1008,1020', '', '');

insert into system_perms (ID, NAME, DESCN, OPERATION, STATUS, PATH, MENUS, OPERATION_HK, OPERATION_US)
values (124, 'AUTH_MODULES_INSPECT_AUDIT', '审核督办', '审核督办', '1', 'inspect', '1000,1001,1007,1008,1020', '', '');

insert into system_perms (ID, NAME, DESCN, OPERATION, STATUS, PATH, MENUS, OPERATION_HK, OPERATION_US)
values (125, 'AUTH_MODULES_INSPECT_MANAGER', '督办管理', '督办管理', '1', 'inspect', '1000,1001,1008,1009,1010,1011,1012,1020', '', '');
SET IDENTITY_INSERT [system_perms] OFF

SET IDENTITY_INSERT [system_rescs] ON
insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1000, '督办看板', 'URL', '/modules/inspect/inspectPort.do?method=inspectPort*', '督办看板');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1002, '新建督办', 'URL', '/modules/inspect/inspectFile.do?method=create*', '新建督办');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1003, '督办草稿箱', 'URL', '/modules/inspect/inspectFile.do?method=draft*', '督办草稿箱');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1004, '待办督办', 'URL', '/modules/inspect/inspectProceed.do?method=findReceiveProceed*', '待办督办');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1005, '已发督办', 'URL', '/modules/inspect/inspectProceed.do?method=findSendProceed*', '已发督办');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1006, '已办督办', 'URL', '/modules/inspect/inspectProceed.do?method=findFinishProceed*', '已办督办');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1007, '督办审核', 'URL', '/modules/inspect/inspectAudit.do*', '督办审核');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1008, '督办查询', 'URL', '/modules/inspect/inspectFind.do?method=inspectFind*', '督办查询');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1009, '督办考核', 'URL', '/modules/inspect/inspectReport.do?method=dispatcher*', '督办考核');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1010, '权限管理', 'URL', '/modules/inspect/inspectObserver.do*', '权限管理');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1011, '督办类型设置', 'URL', '/modules/inspect/inspectType.do*', '督办类型设置');

insert into system_rescs (ID, NAME, RES_TYPE, RES_STRING, DESCN)
values (1012, '督办编号设置', 'URL', '/modules/inspect/inspectSnSet.do*', '督办编号设置');
SET IDENTITY_INSERT [system_rescs] OFF

insert into system_perm_resc (PERM_ID, RESC_ID)
values (122, 1000);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (122, 1002);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (122, 1003);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (122, 1005);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (122, 1008);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (123, 1000);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (123, 1004);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (123, 1006);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (123, 1008);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (124, 1000);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (124, 1007);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (124, 1008);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1000);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1008);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1009);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1010);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1011);

insert into system_perm_resc (PERM_ID, RESC_ID)
values (125, 1012);

SET IDENTITY_INSERT [system_menus] ON
insert into system_menus ( id , name , path , type , icon , url , target , pos , isdisplay , descn ) VALUES ( 7, '参数设置' , 'security' , '1' , 'department.gif' , '../../modules/security/baseParam.do?ec_s_pos=asc' , '_self' , 2031 , 1 , '参数设置' );
SET IDENTITY_INSERT [system_menus] OFF

SET IDENTITY_INSERT [system_rescs] ON
insert into system_rescs ( id , name , res_type , res_string , descn ) VALUES ( 7 , '参数设置' , 'URL' , '/modules/security/baseParam.do*' , '参数设置');
SET IDENTITY_INSERT [system_rescs] OFF

insert into system_perm_resc (perm_id , resc_id ) values (38,7);

--请小心执行该SQL，可能导致其他菜单错误
update system_perms set menus='4,14,1,2,3,5,6,26,74,158,15,889,800,801,890,903,905,970,971,972,7' where id = 38 ;

--为了测试，初始化两条数据
--SET IDENTITY_INSERT [inspect_type] ON
--insert into inspect_type (ID, NAME, POS, STATUS, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, DESCN)
--values (1, '重要指示督办', 1, 1, 2, '2010-11-15 20:09:16', null, null, '');

--insert into inspect_type (ID, NAME, POS, STATUS, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, DESCN)
--values (2, '重要会议督办', 2, 1, 2, '2010-11-15 20:09:38', null, null, '');--
--SET IDENTITY_INSERT [inspect_type] OFF
--紧急程度基础数据
SET IDENTITY_INSERT [base_param] ON
insert into base_param (ID, NAME, POS, CATEGORY, SERVERFILE, FILEEXT, FILESIZE, STATUS, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, DESCN)
values (3, '一般', 3, 'inspectPriorityCategory', '', '', null, 1, 2, '2010-11-15 20:08:25', null, null, '');

insert into base_param (ID, NAME, POS, CATEGORY, SERVERFILE, FILEEXT, FILESIZE, STATUS, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, DESCN)
values (2, '加急', 2, 'inspectPriorityCategory', '', '', null, 1, 2, '2010-11-15 20:08:06', null, null, '');

insert into base_param (ID, NAME, POS, CATEGORY, SERVERFILE, FILEEXT, FILESIZE, STATUS, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, DESCN)
values (1, '特急', 1, 'inspectPriorityCategory', '', '', null, 1, 2, '2010-11-15 20:07:40', null, null, '');
SET IDENTITY_INSERT [base_param] OFF

SET IDENTITY_INSERT [Inspect_Sn_Set] ON

insert into Inspect_Sn_Set (ID, CREATE_ID, CREATE_TIME, UPDATE_ID, UPDATE_TIME, SN_RULE, CONDITION, FORMAT, BEGIN_NO, DIGIT, CAN_BREAK, START_DATE, END_DATE)
values (1, null, null, null, null, '1', '@系统年@', '@系统年@-@文件编号@', 1, '000', 0, '2010-12-06 11:50:17', null);

SET IDENTITY_INSERT [Inspect_Sn_Set] OFF



